﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using ProjectWebNhac.DAO;
using ProjectWebNhac.DTO;

namespace ProjectWebNhac.BUS
{
    public class BXHBus
    {
        Dataprovider dao = new Dataprovider();

        public DataTable loadBXH( int MaBXH)
        {
            DataTable dt = new DataTable();
            if (MaBXH == 1)
            {
                dt = dao.LayDuLieuThamSo("sp_User_LayBXHVietNam", CommandType.StoredProcedure);
            }
            else if (MaBXH == 2)
            {
                dt = dao.LayDuLieuThamSo("sp_User_LayBXHHanQuoc", CommandType.StoredProcedure);
            }
            else if (MaBXH == 3)
            {
                dt = dao.LayDuLieuThamSo("sp_User_LayBXHAuMy", CommandType.StoredProcedure);
            }
            else
            {
                dt=dao.LayDuLieuThamSo("sp_User_LayBXHToanWebTheoQuy", CommandType.StoredProcedure);
            }
            return dt;
        }
    }
}